SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422686 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422686 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513095,603953,325768,891211,526985,665210,724324,327135,347398,499402,886481,640079,685107,597461,648118,459764,212803,238122,233820,1027310,1015999,805379,520768,930105,386108,385250,506375,537819,75607,566223,393487,106061,919374,18149,254413,915320,644909,648816,748704,942364,385253,481138,798914,27407,1014605,554157,614317,168154,7869,537036,977502,876110,769519,623839,559849,319875,281655,841318,323468,244517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]