SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549715 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549715 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652184,402851,825802,126239,348658,581862,602797,31437,1038387,351379,648193,344665,772674,411838,372059,19739,276418,58672,961590,38697,3641,959325,426025,115254,913496,662414,964191,856621,852951,247771,797397,602173,326129,34285,908668,888725,706869,839829,122792,271673,182835,448123,778256,575870,341894,281952,428011,602785,282337,489746,987821,335608,712240,280857,2678,1026396,392523,979648,126261,412823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]