SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003555 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003555 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003692,378265,444397,45661,965600,776288,722565,338632,707083,812229,334117,381210,297289,213897,530353,27375,1022455,392460,846901,761025,239280,967906,917792,398136,21187,742806,850800,169372,805024,445060,735068,777103,169874,58218,55974,993059,257219,1002221,440471,874308,779010,54803,598076,315340,386415,288110,487986,688503,1008758,738773,299889,528337,559094,268313,599451,405527,705828,658596,228940,212075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]