SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420448 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420448 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418906,819440,179769,935779,674830,1042565,1027547,526746,18628,63801,202178,779036,56394,853442,168248,175977,359682,520179,276080,402653,971816,846063,859344,56216,671083,981058,221193,561632,389375,848427,1025730,26967,225687,317139,258107,865878,391407,947319,751167,139109,282922,205649,149252,154726,1031953,1028737,404618,463820,685895,305814,740642,962928,962762,185526,1041551,355509,762091,1004987,988499,283191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]