SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397866 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397866 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393911,365183,804909,987106,828025,616708,245180,511326,119606,848908,662649,359918,364832,442640,491932,283646,915669,631059,386262,651850,608698,135772,565482,1030266,1018304,1030819,499156,438828,82143,353129,1016056,881133,1005158,979675,319963,309486,988306,465953,77249,800464,617139,166402,980789,434236,390763,1008918,1030166,612030,471564,833914,219169,156418,268584,235750,999347,232682,259055,794548,451115,7939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]