SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562105 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562105 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789691,407801,911626,386160,579337,740219,247619,991437,50779,372536,883960,844009,335963,795139,642655,870740,150611,129693,883229,129989,245704,145378,475531,344447,559361,407472,22189,681165,405338,451560,289424,823678,95842,577246,84093,326058,882596,992280,744676,679504,938153,924588,789701,751934,726278,836917,1014827,837688,150503,436991,90053,104106,739165,529156,110084,222806,839115,377977,754396,463394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]