SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003498 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003498 [ RunTime:0.002986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201149,293015,234750,496653,812636,807351,875462,965196,135032,912692,50893,139477,689284,194400,1028438,213843,476592,882077,125432,825691,517661,908663,233413,37719,57706,288810,828178,400496,869685,678934,195662,369098,90341,109357,295593,821992,97687,527028,689109,900386,1048807,963394,581009,108687,106621,578687,245805,287581,932057,949663,624057,423105,862061,779896,308978,178753,902579,455594,363807,541671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]