SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80148 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80148 [ RunTime:0.005703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935600,338235,531227,357863,220045,556011,76084,158717,219808,374441,204813,767507,151972,581775,901738,193935,170481,25376,7733,914114,447020,310958,388216,147050,675314,983230,815506,848244,279143,221418,528696,991724,26002,716145,553998,242521,498132,224027,879547,919505,456450,929308,981419,526158,1008074,111455,902387,511841,688162,884110,439742,712153,288695,516838,612184,830777,356343,87848,713976,411130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001075s ]