SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401683 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401683 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747066,705407,781944,1014290,952931,588428,469739,375568,145870,6795,379068,539239,356564,179454,589605,560606,822549,260858,123968,976935,478387,1000063,468896,447731,538954,450720,297566,719512,1008270,522372,739698,792343,374132,114975,184119,940161,776441,39187,943837,692776,949343,56320,759264,354677,514121,796638,53386,723320,484739,770892,794419,312997,609633,268437,508306,550950,366306,258460,836289,912162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]