SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107511 LIMIT 1 [ RunTime:0.001017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107511 [ RunTime:0.002753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230611,6933,465903,562331,871792,371923,257242,883476,992146,817481,586697,1047233,681167,794833,928890,524954,841371,31122,659892,515315,886074,280377,93588,596136,797631,107020,644638,903365,680956,946011,1001429,918442,230384,307071,787800,467796,953738,1031729,118828,311506,730869,549664,948487,800930,73711,850456,739317,757482,952711,386996,20694,494950,310582,230654,685788,482065,118372,601152,154419,744820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]