SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018802 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018802 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350576,664381,184804,737031,412536,909125,69135,527737,1018541,1048063,415745,747600,184846,622923,552564,118000,747847,860696,276789,531899,120091,224679,1021088,78656,771494,283653,593951,109485,993132,100759,654491,602822,159227,709375,794017,250110,224764,520730,137931,34627,795158,412393,287698,242973,63336,1039589,827444,476959,495633,281307,182076,116568,62060,134274,454866,449133,477736,821675,328992,130685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]