SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212014 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212014 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930294,433874,671361,742493,345880,775927,504735,347290,740018,112050,507958,511551,886705,83534,470693,945801,680290,15002,704128,287533,912031,954169,781613,744034,381698,195507,5345,176831,207827,465223,713523,583496,152385,435906,787384,65762,25548,166257,568401,183174,939146,264909,1271,60153,184219,850512,478136,226697,25698,166225,683975,638830,112943,517107,940998,309739,834442,938611,660388,901268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 212014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 212014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]