SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015868 LIMIT 1 [ RunTime:0.005325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015868 [ RunTime:0.004837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533080,621776,57412,507979,538049,968613,589706,39628,1026481,63607,544645,1037063,127718,942831,900655,497090,905580,826331,57096,428780,302567,465501,906908,993958,746671,464931,436484,44585,356092,950215,909381,213681,674518,1037123,206560,967592,334803,611025,548872,191287,835313,969915,314345,131597,699126,364944,429469,849676,397448,162540,943063,929726,421224,345021,581180,252768,720666,159302,557375,359921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]