SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543693 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543693 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780868,997541,276602,854699,769458,639409,1015769,577849,182833,515911,809441,271322,1027141,228393,220388,708940,737280,91636,600067,514682,371671,574706,25911,210202,938524,530788,552203,516105,850728,935524,18821,306007,843553,113567,76393,342081,946112,154097,297249,434442,410870,293789,925538,223356,942950,298485,299613,581399,972963,514567,82875,641915,603314,72857,108931,791521,260671,470557,231686,926099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]