SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280604 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280604 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20569,259907,954849,738604,10504,331450,409732,118573,248682,866100,682568,209336,611541,89380,600354,432814,176551,163481,320409,392301,975317,587105,625679,186805,830855,578577,783272,282494,775531,660199,1002260,473138,769746,1042870,338828,435062,954049,953936,529804,1038190,248789,201576,1000675,859660,680886,39878,893458,493405,39138,406723,573801,406145,260532,775441,485306,511315,930939,415926,508279,208639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001891s ]