SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8150 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8150 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387820,754048,742430,676326,838792,1012249,853437,119204,531599,57655,1044335,105391,648310,1040676,884002,944098,388861,356027,135737,750821,386009,484391,947148,536528,255229,633158,87328,923552,135804,208198,96760,262051,270201,878044,321933,285105,89493,393127,815281,631286,299607,17746,380734,589630,14004,689709,918869,580170,93903,738024,1026808,103842,104972,112284,166212,199578,631191,951162,1048582,397308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001662s ]