SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198016 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198016 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115404,175836,67906,439456,823531,197961,370294,1034712,468080,321321,1004333,368389,142452,172870,825568,610116,404152,684800,862489,790207,923421,384799,648169,295966,117436,150775,632278,849856,386355,555180,764048,153369,655342,74694,891587,627359,530333,896909,712192,852563,876910,895695,804524,11409,840195,1016791,25858,787033,550094,962856,594733,255253,12725,321368,974363,746813,667349,730557,359592,5016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]