SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311288 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311288 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307559,122527,732879,997662,1013870,566078,102553,162270,153334,179916,72008,817690,947643,892640,760662,712153,336439,273565,559321,950351,527671,178145,287628,508303,608924,1027850,430840,937795,241158,451906,32949,229882,971544,1037309,7783,307870,561635,128867,580823,797333,766564,204224,161575,191580,480844,192434,146325,304551,1017341,145320,996396,396072,750891,591021,281394,375248,1036967,976619,357412,923849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001625s ]