SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421714 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421714 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180835,483445,152381,20529,155183,723691,925029,965752,384320,620189,516506,998901,715717,987901,210872,176709,412792,882686,66037,928060,374041,885385,635692,362406,677068,89125,999556,538644,82155,391318,662035,771668,906074,947082,865931,598090,113205,826737,626103,847242,289448,218184,411979,126034,986993,937595,134663,1044483,400609,317651,824441,765114,595132,74078,718224,998804,548290,96,617451,418747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]