SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031750 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031750 [ RunTime:0.003993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046287,507381,1010842,871518,420529,345739,992436,28293,899929,1040393,106794,881818,211771,647885,330064,502432,498132,895734,38754,841888,403593,706468,1022934,822920,582602,406535,870615,207104,697960,565110,587363,59090,1040101,590692,890285,82652,919068,875378,323581,434629,817599,301776,118286,479784,873123,979578,14874,142872,444654,940710,669556,737229,567242,943551,119465,197509,549579,823352,175768,759121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]