SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311089 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311089 [ RunTime:0.002441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264878,338183,699313,503126,793024,166823,148818,694621,716772,385250,509851,566966,383312,61555,455213,101636,476568,381527,623080,233106,60520,412123,195831,531156,871922,464000,197694,221769,561077,27326,1046683,507064,247176,789080,935184,544997,601004,325300,419384,146425,216520,896828,107432,820117,384051,327729,904296,162249,187847,900503,562088,982174,662784,471809,815787,182696,590232,147386,73642,74486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]