SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34164 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34164 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131166,315742,502745,603772,168567,597291,402971,450206,552247,881014,150537,1011791,901718,407247,330284,968829,625619,771683,660121,719183,267571,272985,35239,631367,373220,911415,20302,227836,354418,250522,476079,382180,664658,764845,586049,97612,1010950,590376,549319,434334,322749,966926,288712,650987,801166,145815,313311,179928,44008,611049,611102,314450,58287,945304,307798,1019799,75790,938063,238875,80692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]