SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025347 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025347 [ RunTime:0.005868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200531,970477,312023,849615,619470,628064,999644,1824,102308,506764,188609,391256,393079,948485,74809,768565,447368,339253,19634,585927,286409,295797,1043427,867298,713832,216084,1005892,767598,583147,223703,850364,315296,651343,654047,1044099,485811,999168,804654,536309,489622,160225,276280,272786,996904,784794,778840,921950,123009,341028,797285,596003,355335,89694,825224,483429,196779,186943,20476,339054,978324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001106s ]