SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416857 LIMIT 1 [ RunTime:0.001281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416857 [ RunTime:0.007389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251959,119683,650455,271875,350379,963794,760716,549846,923099,337508,606021,11765,899436,146892,702019,735541,185638,269972,861181,272650,184220,336311,774010,513273,743193,183875,513599,360916,197424,628348,625033,422779,774533,542122,353845,114918,361349,938228,317274,386688,531366,187370,356822,551853,99001,593629,659439,228567,862195,109606,395669,1001397,460136,1026407,178663,43374,341710,59198,824281,878853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001454s ]