SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401095 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401095 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816487,1003199,83356,572099,694265,95857,594095,35826,937948,135198,378490,538204,335893,930783,271525,556683,209417,430197,41178,443489,471977,760955,366648,144953,600629,438654,410904,592701,115542,340118,265556,21700,390255,554763,70235,595201,840862,574748,743001,448545,547982,235813,739717,279450,568822,1045524,1020807,805174,784196,833853,92562,963608,946591,660575,14763,398815,83310,107916,549974,525887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]