SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293448 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293448 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384683,841772,567702,455484,860719,134050,353641,432575,385381,265313,329811,179607,780105,116424,796608,587607,951664,31194,360825,839299,987247,785858,1029870,565459,977399,983797,283405,924627,355603,564214,79122,472161,885004,563751,1024040,413472,112309,799623,112965,499525,151147,792793,721985,390029,560356,386901,314752,147061,907449,694885,195486,530460,583477,573538,876473,160302,269080,993353,186987,988760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]