SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564943 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564943 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738517,732269,52387,247056,399241,794145,478127,532073,821559,720785,1003116,455817,300318,48575,284724,117909,329974,584482,808882,11508,893487,570956,642489,402163,124420,345361,155269,721740,476962,564686,79468,57782,806881,7111,647371,197127,344914,729318,744092,737194,1012134,933039,280600,451893,473404,835431,1039600,410902,440043,667636,293513,678163,167125,535140,497902,945016,796758,69464,61111,321995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]