SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532941 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532941 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647663,339130,546771,873127,263867,970993,485598,1034829,912345,594375,728668,852089,993951,974730,27726,549693,645525,614348,759508,928770,1024520,159684,255909,864839,607120,1012439,31588,661773,781743,581527,358369,556763,537510,496614,154776,857020,147178,82863,828157,100886,666173,837897,395582,485283,202211,317058,327348,903449,883603,366959,828542,239481,891733,295459,486511,580890,126780,579785,834027,208998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]