SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001760 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001760 [ RunTime:0.005470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816938,947612,751671,145735,201026,454945,423883,618812,761856,661801,994914,493328,292318,472539,305468,623631,686368,745109,419258,881280,4862,79607,581725,502310,376049,547640,355104,965921,167591,882412,930238,1026948,641787,412771,704808,308095,372099,630422,401770,251742,740044,105090,298268,985125,577365,399835,878137,944049,318655,620626,236271,162206,296421,267091,555933,771157,384769,103626,178766,181595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002331s ]