SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 13014 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 13014 [ RunTime:0.002623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308456,923242,497781,331917,216743,229800,195571,794657,711999,1012865,78628,746847,316444,260384,538262,760722,482580,567301,556779,1042017,114278,375753,57385,1005684,864845,326636,579392,62295,108539,596579,875537,210571,446848,858687,96089,67560,188440,451732,571895,137984,590484,216480,616104,771775,352913,837418,825868,795147,122266,40181,340834,1000838,758651,38597,785527,383207,475660,1022991,728544,780870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 13014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 13014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]