SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549078 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549078 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802251,71558,16311,511688,531465,429215,438496,238484,674804,521986,299840,376408,634266,19734,572700,603940,278746,402834,143255,1006288,214736,704184,712618,1002746,388883,928892,375175,636774,144949,548978,203909,848887,168440,560271,789844,305376,106751,281591,174015,477638,1004852,1028,903573,140293,152223,647202,379810,547518,594560,383564,636946,79806,49758,376078,148300,702540,579505,202126,413278,812795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]