SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45383 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45383 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347047,67351,577775,514947,270568,483708,1002222,894278,926983,319353,691299,273595,448866,1035959,579143,781127,1026101,21905,845669,567622,163186,802373,771899,431067,443543,341320,112629,486146,261627,712297,1007289,191396,514713,914119,990375,487263,969709,302194,556795,927865,332402,5998,901742,391036,939489,244367,615372,7528,319421,428761,125993,767954,130296,812767,753440,480322,913047,927022,110027,860454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]