SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031760 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031760 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288214,980752,472279,191726,692586,341696,331227,722097,284697,14799,425207,13855,348323,582791,882651,490902,995299,638295,417048,640547,211290,488873,971058,423697,308181,182175,911895,303366,231608,201707,87203,991628,431695,51391,401554,675421,174886,1030783,966309,977339,916061,898162,666689,892061,514506,423822,453752,1026764,676734,422935,414839,354147,539063,702278,118079,847626,221005,59649,360136,52431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]