SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335400 LIMIT 1 [ RunTime:0.002677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335400 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490036,216010,346775,223152,1029158,52080,216264,443964,536624,1019655,740745,489265,1048335,32027,754216,483403,41917,417047,911813,246033,107225,384544,636110,64043,634646,26786,848010,443551,639004,285465,14731,374803,115956,368354,880031,331115,743965,585829,455935,957104,978864,452443,41915,552789,609848,582251,315007,123629,589172,349757,838434,76403,41694,858699,741242,446999,781693,706241,66632,892684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]