SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34778 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34778 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311556,893232,899840,724250,295438,115947,958178,555435,371824,577110,930538,678960,393236,834126,438616,659503,849502,347890,808116,439032,838590,184444,1045359,560961,96897,398523,681412,901480,755320,930589,896130,43277,135920,108528,455010,398393,241808,529152,928210,869431,515284,696766,426,892586,494613,68245,456668,375564,751093,19559,923094,6187,692804,289861,647365,971480,399318,962645,995890,1002391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]