SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405397 LIMIT 1 [ RunTime:0.001010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405397 [ RunTime:0.003114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118324,706144,861357,858806,387172,1027394,147764,661879,687992,99710,177242,42347,718583,837160,20064,434015,1013350,252919,526030,301099,414695,341543,640776,29316,330370,768617,144820,448540,874331,953273,977321,440694,560488,492263,691977,926575,811708,521494,119339,786398,580332,344018,986383,485420,957877,385808,392030,115044,193651,1028451,26482,30996,638778,810020,761881,828093,500471,350461,41077,847140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001060s ]