SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 723253 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 723253 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873840,40888,846483,509703,574786,86553,347487,1000359,143493,283868,554968,611907,373982,577259,460573,592750,911192,1034230,782039,109253,1028455,1048768,942625,807623,802777,240362,510746,591882,168718,299890,268863,11620,722451,264120,83067,486209,948038,1004013,616273,221380,691076,689727,218202,1040848,526517,853059,996523,458317,585713,36940,992707,238395,162294,151975,801488,682347,49195,517039,559256,564646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 723253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 723253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]