SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018140 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018140 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808691,238669,670661,490228,816271,424093,355045,690148,868311,161820,259170,1023292,744329,43076,231183,1036167,1003334,469605,902474,126006,885091,660159,11702,813135,159309,659878,742773,736357,321654,409129,489430,990022,936775,254790,444458,589194,716750,202362,894006,752641,695378,958524,531484,78589,1047746,154639,308317,1005286,394739,147381,490837,455702,486562,449341,665238,102965,159528,10384,325724,291754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001656s ]