SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025530 LIMIT 1 [ RunTime:0.001240s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025530 [ RunTime:0.003504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455131,635294,460826,118417,835424,372363,533271,337768,1016193,66174,134891,212185,308748,527137,975551,762500,42445,457985,527937,978438,31069,564907,549869,373145,916593,253670,51855,179412,13693,750222,169471,807039,225020,207243,259389,551084,69544,454563,487001,612556,377523,631125,673430,810613,946003,496237,84570,161281,833751,889480,775638,467328,586875,678522,171112,568772,63346,626418,304011,397458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001381s ]