SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200910 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200910 [ RunTime:0.002838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887156,355977,564454,331054,132389,746322,159402,556149,392505,17850,1028700,1003259,436436,849395,353528,341882,604686,271266,269834,824766,748816,275934,120907,612937,470655,463725,448986,57157,1020484,129119,673027,403805,881716,300914,69752,343642,238351,26337,259809,537698,74467,911357,623510,247779,349819,533501,123649,274197,804155,942599,103203,322788,370355,557498,28470,191644,1005188,339064,810389,1007450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]