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` = 366438 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 366438 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554041,142013,669601,1020601,893764,962703,607412,265751,488567,936619,182459,167459,323921,479534,911005,786646,566420,338051,28814,253632,149027,860305,1018223,307910,573350,107504,525229,551815,18441,229400,598407,832634,662149,317165,511167,179147,162381,908979,80553,833784,15755,410004,975959,875487,313060,879696,917045,131334,636175,921141,572470,92460,223918,797693,361099,216437,201156,79395,560757,464316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 366438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 366438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]