SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489093 LIMIT 1 [ RunTime:0.000867s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489093 [ RunTime:0.003509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827208,658436,9493,480630,171852,179077,26642,383811,302550,497149,679086,76697,887788,955898,1033408,286796,546269,34781,747001,933492,513368,48635,190402,864146,1042945,870678,730000,783223,942739,557879,444419,604392,574090,540249,1005945,244447,341785,493337,43950,300122,1000910,133348,217611,353648,908921,145683,370092,844905,382366,380207,510221,787114,1029593,756665,844055,800850,799104,50420,911533,538069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]