SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038700 LIMIT 1 [ RunTime:0.003246s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038700 [ RunTime:0.004540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586923,247042,578352,88882,56235,747956,177627,109082,426422,476595,268363,79360,990018,586476,750116,378892,258497,579016,481750,631479,980703,610175,579975,312458,464823,518578,991341,946974,326938,37056,452113,672488,550184,529164,554991,791437,244756,154605,424506,820949,895498,928000,820252,131223,28636,102253,933948,1008501,671937,117711,279277,268125,977492,362185,800481,612721,566257,281779,676559,566358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009006s ]