SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512097 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512097 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254064,150864,614018,434733,535086,24655,879943,1028344,833035,384639,643373,570127,296280,87730,685739,1042434,1038128,635823,414753,546235,55141,947611,294810,839129,427823,990344,337421,386086,438464,477970,120325,102594,159571,745342,1027441,1046614,804618,650349,41987,493295,601329,426416,714570,195618,711568,709396,528820,642599,152176,10571,533263,218592,464339,736107,609112,110798,999840,544173,502614,734768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]