SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468511 LIMIT 1 [ RunTime:0.000903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468511 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542291,1026199,80706,1024606,857697,866102,403292,742181,276170,282197,325811,86422,753622,80715,70482,317631,658563,864603,849263,236589,637757,261023,1030884,805073,676392,404461,248795,715129,351487,275927,96462,632953,516471,556933,164598,1011558,819678,37019,249215,818422,1042763,238480,448633,356849,1046357,724493,1038973,786691,890633,290866,220160,587546,563461,973939,843690,280764,260074,866808,811861,351758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]