SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564473 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564473 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996204,916900,643867,473158,780205,877973,257568,25070,346224,493661,759030,946106,703481,193235,764216,447281,252947,717424,497461,139007,430351,434071,502962,883353,245381,466275,785826,283147,754718,230058,791549,70277,35803,364212,673384,450448,686524,5984,351570,260046,491908,209432,415394,949884,271797,730256,527832,164286,462775,42498,112593,193059,263140,987377,554614,540228,672721,834194,517387,858051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]