SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310896 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310896 [ RunTime:0.003033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914249,692833,220826,31772,446275,209698,1012686,730751,757260,377374,953253,318511,80608,124238,524728,320987,489264,197777,235202,402693,566901,292548,122652,990282,633607,814605,807838,480686,213051,687257,621374,429719,920016,955866,1017919,484763,232434,1046016,783207,561627,47468,494226,68777,925670,385424,13709,8548,655888,278657,347206,840408,435467,737117,957754,148965,641382,292503,13665,570463,15023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]