SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101814 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101814 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809896,168094,800612,199860,383224,692701,907342,845901,246603,952603,520471,817230,495947,519585,805363,91025,461027,341621,765210,607291,350186,58325,529379,769456,6127,501117,238884,507698,490292,219460,44126,864363,692149,844555,84989,300334,27904,463581,633281,908899,661271,20490,208977,495514,530956,862546,558442,528073,187262,101111,994615,511024,650110,89561,43849,380120,517729,377969,806822,1004925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]