SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418652 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418652 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96961,77583,274977,230632,771938,476264,206865,173163,39295,487961,642648,738745,92725,917242,637023,124606,575501,97788,153027,79233,226858,744049,125489,711526,1043590,355475,383406,117967,573692,103472,268932,120052,564810,653107,984735,636661,50804,368771,338789,925135,1036443,490740,599822,772521,237666,68334,470595,660418,362169,26845,668617,126646,897197,765627,747066,98666,792684,771435,467587,763602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]