SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 692001 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 692001 [ RunTime:0.005654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646889,822464,416461,597252,694684,10830,386812,766777,937787,376003,229468,141765,138765,528354,409909,173690,343118,1019098,406334,993446,524948,283333,133419,958978,634969,833277,593998,905976,103762,649608,445220,904308,377907,929851,748856,374378,171183,957514,836618,801313,37752,399779,311330,386718,476198,392261,1045690,1035264,281151,969849,1009046,152644,258881,1039753,974062,621291,871124,64364,115222,231877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 692001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 692001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]