SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565182 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565182 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553439,483625,760839,33468,527690,878428,650465,303522,838791,29682,357901,426072,27683,392939,632078,31328,480499,367373,746607,224195,836350,113218,49923,1044251,346173,470768,1036641,330441,987888,528270,154951,583078,929663,598128,765622,381745,897676,196632,734005,667700,246094,571178,914221,815536,494702,853934,1042817,558840,561278,426417,1007171,153732,792945,284688,260256,350529,295163,778288,1033307,49983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]