SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433571 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433571 [ RunTime:0.003281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013493,121933,1047339,763462,387913,538704,343036,645354,312012,709760,468602,901704,801623,1042800,848849,81989,836873,171894,916437,234935,245124,601001,453428,1020044,286631,442181,571630,1018526,17266,667318,700902,864279,646843,731841,204792,886357,755990,845194,698084,922353,277809,644388,351767,686663,402294,7090,326322,475576,10150,185066,439001,171791,543490,31393,539486,255670,731700,317650,510743,881136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001793s ]