SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017025 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017025 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292110,285016,336814,944794,243504,85226,47264,965922,887267,743764,204710,537714,847907,54780,63992,450984,155594,669625,514624,223488,461406,811998,237669,748056,982672,656593,188586,117364,262957,494430,362617,368097,759967,362501,324512,924590,1041353,337498,563305,800561,656595,706508,394712,968872,144298,51959,490811,597828,940252,846583,724268,409127,122058,1025028,161475,799891,910998,570652,123587,632643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]