SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025686 LIMIT 1 [ RunTime:0.004138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025686 [ RunTime:0.006200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427729,227923,187802,794602,331861,490762,882182,498822,834529,873044,898177,110824,200967,690378,286731,880246,1020528,922266,357554,489503,245585,65908,1044021,704422,50474,346954,782593,160070,265754,131877,120624,587875,1026565,276928,726478,895037,918871,688085,156773,618004,954290,100409,855340,786993,871152,284263,826054,54583,336028,118516,143961,107739,61008,548696,624607,481424,170940,29996,481810,944892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]