SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108335 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108335 [ RunTime:0.004346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300536,945206,413016,417595,201290,726053,559132,614980,402279,362112,692696,420717,409412,248144,297646,730350,804117,267999,269994,106485,333132,636147,852699,671779,606682,784256,11849,833492,914629,573447,663984,108068,864988,154808,1040931,693638,795290,612305,738464,384608,446571,907253,681085,316999,671456,299222,362216,781924,813924,272764,731648,209655,467840,728508,574543,648738,918597,51146,90106,1047071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]