SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675648 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675648 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204252,49214,632844,355033,400445,551832,999145,38303,999228,42369,925771,680100,284322,341352,549291,815993,658074,1025183,69375,876864,855775,151255,2121,404369,446663,234822,829040,1016084,798513,296886,1017486,667490,177104,726730,719393,812533,952550,508593,755885,619636,236938,364009,36729,603455,971622,291882,768178,973594,369449,83102,284495,204168,331428,655183,116203,264020,656828,33569,789926,1018146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]