SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405670 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405670 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245806,1015193,626526,755464,614129,280853,986362,627114,737984,663336,491404,906534,117159,959858,396260,556026,165916,1039173,757286,784910,711624,25490,251805,206617,141812,1673,427880,102196,3665,630322,729695,784795,1039766,416355,416232,593189,385296,132884,503657,182006,318490,461021,595460,525748,137247,941041,991467,270030,42382,483361,249157,420455,977800,40983,905011,645392,341861,693115,650876,920011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000952s ]