SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574078 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574078 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287194,120924,612154,819246,597128,195838,1022207,313537,630651,556588,745582,54074,777587,652829,593327,70240,819111,838969,961618,698245,11064,322989,203449,590311,289680,297455,815217,342728,345419,484878,344751,1024750,219514,243218,574011,865419,305841,566595,937561,672830,191664,521754,54716,839194,553253,542625,127252,424989,1007986,725231,610536,889566,528535,159878,392148,767853,493440,115020,357980,440334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]