SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017781 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017781 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319542,315715,511197,799418,11430,624099,619198,822469,500854,179999,107487,251132,927492,765785,569091,756093,316872,26617,231255,124218,80726,244481,867754,714126,150874,586890,803099,143198,901761,981706,254187,305703,506786,955724,512895,722978,40903,800201,154405,364007,792236,114808,501314,798136,948437,1017587,874328,999468,120932,635264,551175,559294,628100,43015,283983,48963,713245,108779,574280,948318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]