SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501036 LIMIT 1 [ RunTime:0.001340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501036 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026337,464648,762167,861187,1002671,107939,267985,246800,29442,631117,725872,897583,883790,285905,420972,133066,211082,436956,638427,720120,523511,481356,596398,698072,818339,405832,329500,233721,128726,209437,844723,123768,494345,262541,1041223,223634,140593,525543,657720,578059,713506,676273,645486,719044,488075,727194,173431,30743,182943,814372,245588,896963,434631,483814,42414,202855,665173,529428,279080,782842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]