SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972703 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972703 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363916,197440,528944,698908,898776,93460,409560,938982,975140,925068,476798,319947,316215,63897,164960,1019605,123032,481778,901626,708510,936193,835482,988070,422855,647207,580638,352422,672520,905248,631359,822498,764021,595749,286196,992684,140472,436364,1025045,427688,259828,539603,675294,143399,205748,234300,685656,11095,758042,154965,870871,787131,751544,326518,610612,288033,375556,357415,883196,427310,202613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]